Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_2201

R_2201

PhStItem

PhBlockade

StItemID

 

 

R_2202

R_2202

PhBlockade

PhBlockadeLot

BlockadeID

 

 

R_2205

R_2205

PhStOrder

PhDelivery

StOrderID

 

 

R_2206

R_2206

PhStDoc

PhDelivery

StDocID

 

 

R_2207

R_2207

PhStDocItem

PhDeliveryItem

StDocItemID

 

 

R_2208

R_2208

PhStOrderItem

PhDeliveryItem

StOrderItemID

 

 

R_2211

R_2211

PhDrugAdmMeth

PhDrug

DrugAdmMethID

 

 

R_2212

R_2212

PhDrugForm

PhDrug

DrugFormID

 

 

R_2213

R_2213

PhValidityPeriod

PhDrug

ValidityPeriodID

 

 

R_2214

R_2214

PhStorageCond

PhDrug

StorageCondID

 

 

R_2215

R_2215

PhDrug

PhDrugAtc

DrugID

 

 

R_2216

R_2216

PhAtc

PhDrugAtc

AtcID

 

 

R_2219

R_2219

PhDrugFormula

PhDrugFormulaItem

DrugFormulaID

 

 

R_2220

R_2220

PhDrug

PhDrugPrescriptionType

DrugID

 

 

R_2221

R_2221

PhPrescriptionType

PhDrugPrescriptionType

PrescriptionTypeID

 

 

R_2224

R_2224

PhDrugProd

PhDrugProdItem

DrugProdID

 

 

R_2225

R_2225

PhFormularyType

PhFormulary

FormularyTypeID

 

 

R_2226

R_2226

PhFormularyType

PhFormularyTypeText

FormularyTypeID

 

 

R_2229

R_2229

PhImportAppStatus

PhImportAppStatusText

ImportAppStatusID

 

 

R_2230

R_2230

PhDrug

PhIngredient

DrugID

 

 

R_2232

R_2232

PhSubst

PhIngredient

SubstID

 

 

R_2233

R_2233

PhSt

PhInventory

StID

 

 

R_2234

R_2234

PhInventoryStatus

PhInventory

InventoryStatusID

 

 

R_2235

R_2235

PhInventory

PhInventoryItem

InventoryID

 

 

R_2237

R_2237

PhLot

PhInventoryItem

LotID

 

 

R_2238

R_2238

PhInventoryStatus

PhInventoryStatusText

InventoryStatusID

 

 

R_2239

R_2239

PhDrugProd

PhLDrugProdStDoc

DrugProdID

 

 

R_2240

R_2240

PhStDoc

PhLDrugProdStDoc

StDocID

 

 

R_2241

R_2241

PhFormulary

PhLFormularyResource

FormularyID

 

 

R_2242

R_2242

PhResource

PhLFormularyResource

ResourceID

 

 

R_2243

R_2243

PhOrderToDeliverer

PhLOrderDocument

OrderToDelivererID

 

 

R_2244

R_2244

PhTradeDoc

PhLOrderDocument

TradeDocID

 

 

R_2245

R_2245

PhStItem

PhLot

StItemID

 

 

R_2246

R_2246

PhBlockadeLot

PhLot

BlockadeLotID

 

 

R_2248

R_2248

PhSt

PhLotInSt

StID

 

 

R_2249

R_2249

PhLot

PhLotInSt

LotID

 

 

R_2250

R_2250

PhIdentifierType

PhNextExtIdentifier

IdentifierTypeID

 

 

R_2251

R_2251

PhOrderStatus

PhOrderStatusText

OrderStatusID

 

 

R_2254

R_2254

PhTenderList

PhOrderToDeliverer

TenderListID

 

 

R_2257

R_2257

PhOrderToDeliverer

PhOrderToDelivererItem

OrderToDelivererID

 

 

R_2258

R_2258

PhStItem

PhOrderToDelivererItem

StItemId

 

 

R_2259

R_2259

PhOrderType

PhOrderTypeText

OrderTypeID

 

 

R_2263

R_2263

PhResource

PhPack

ResourceID

 

 

R_2265

R_2265

PhCompany

PhResource

CompanyID

 

 

R_2266

R_2266

PhResourceType

PhResource

ResourceTypeID

 

 

R_2267

R_2267

PhResourceType

PhResourceTypeText

ResourceTypeID

 

 

R_2268

R_2268

PhStType

PhSt

StTypeID

 

 

R_2269

R_2269

PhSt

PhStDoc

StID

 

 

R_2270

R_2270

PhStDocKind

PhStDoc

StDocKindID

 

 

R_2272

R_2272

PhStDocStatus

PhStDoc

StDocStatusID

 

 


2  3  4  5  6  7  8